Skip to content
Discussions
Get Answers
Announcements
Events
Product Ideas
Sign in
Try for free
Peter Kirkham
Peter Kirkham
Search
Search
Home
›
Peter Kirkham
›
Insightful
Peter Kirkham
✭✭
Overview
Overview
Roles
No Roles
Badges
10
About Me
About Me
Not much happening here, yet.
Analytics
31
Posts
0
Visits
43
Points
Nov 12, 2015
Join Date
Jul 24, 2017
Last Active
Reactions
Insightful 1
1
Vote Up 2
2
Activity
Posts
1
Comments
30
Re: Turning flag red with conditional formatting
Peter Kirkham
07/24/17
Ryan, You need to nest the formulae correctly. AND(Condition_A, Condition_B) IF(Condition, Result_If_True, Result_If_False) Nests as follows: IF(AND(Finish20 < TODAY(), [% Complete]20 < 1), 1, …
2
·
Activity
Posts
1
Comments
30
Badges